Payroll Reporting

The Payroll Reporting area is used to display the hours employees have worked on a given production Job or for services performed in a given time period, such as days, weeks, or months. In DEACOM, Jobs are used to collect the hours employees have worked, the location where the work was performed and finally the operations or activities carried out in those locations. For activities not directly related to production, a Job containing a non-stocked item may be entered to collect employee time. The process of collecting hours is handled via Production > Payroll Entry. Users may also generate a "Job Payroll Shifts" report from within the Close/Relieve Job form to view the hours logged for the job and, when appropriate, add time entries. When posting payroll data, the j3_laid (Worker's Labor Group), stores the Worker's Labor Group at time of posting to the dtjob3 table so that it no longer considers the users most current Labor Group the one it was posted with.

System Navigation

Production > Payroll Reporting

Payroll Reporting pre-filter

Field	Description
Report Type	Pick list used to select the kind of report to generate. Users with permission can create unlimited user versions of any payroll report and also determine which reports each user will see in this field. Options are: Breaks - Lists the start and end dates and times for breaks taken by the listed Workers. Users can also use the "New" button to manually add break times. If a worker is currently logged into a job, the system will display the following prompt: "This worker is currently logged into a job, please add breaks after they have signed out." Users may also modify and delete breaks using this report. Current Activity - Lists Workers currently logged on to a Job, the start time, date, total hours, the break start time, date and hours, as well as the facility on the job and the Workers Labor Group. Job Current Activity - Lists Workers currently logged on to a Job, including the Work Center, Operation, start date and time, and elapsed time. Job Payroll Detail - Lists the Jobs, Work Centers, Operations, and In and Out hours for the current Worker. Job Payroll Shifts - Lists hours, including date and time, for the Labor Group to which the current Worker is assigned. Job Payroll Summary - Lists regular hours and OT hours for the Labor Group to which the current Worker is assigned. Sign On/Off - Lists the date and time in and the date and time out, including total hours and break hours, by Worker by action. Worker by Day - Lists one record per worker, per day for all worker activity. The report includes columns for regular hours and overtime hours. Users can double click on each record to display the associated job payroll detail report. Workers by Job Category - Lists regular hours and OT hours by Job Category for the Labor Group to which the current Worker is assigned.
View	Pick list used to determine the Workers who are shown in the generated report. Only available when "Report Type" is set to "Job Current Activity".
Start Date/End Date	The report generated will include only work done within the dates selected. "Start Date" defaults to the first date of the current year and "End Date" defaults to the current date when the pre-filter is opened.
Worker	Filters report results for the Worker selected.
Labor Group	Filters report results for Workers belonging to the Labor Group selected.
Facility	Filters report results for Worker activity on Jobs with the selected Facility assigned.
Work Center Type	Filters report results for Workers from Work Centers assigned to this Work Center Type.
Work Center	Filters report results for Worker activity in the Work Center selected. The work center searchbox will be filtered to display only those work centers that are associated to the shop areas in the facility selected on the pre-filter.
Operation	Filters report results for Worker activity on the Operation selected.
Work Crew	Filters report results for Workers belonging to the Crew selected.
Job Number	Filters report results for Worker activity on the Job number selected. The job number searchbox will be filtered to only display jobs within the facility selected on the pre-filter.
Job Category	Filters report results for Worker activity on Jobs within the Job Category selected.
Account	Filters report results for activity performed by Workers paid from the selected account.
OT Account	Filters report results for OT activity performed by Workers paid from the selected account.
Display	Pick list used to display posted and non-posted payrolls in the generated report.

Payroll Reporting calculated fields

Report	Field	Calculation/Definition
Job Payroll Detail	j3_calctime	Breakdown of applicable time for the specific job. This field will also show split time when a worker is putting time against more than one job.

Payroll Reporting report

Opened via the "View" button on the Payroll Reporting pre-filter.

Button/Flag	Description
View Detail	Opens the detail of the selected record. Differs depending on the generated report. For example, clicking this button while viewing a "Job Current Activity" report will display details of the selected Job in view mode; clicking this button while viewing a "Job Payroll Summary" report will generate a "Job Payroll Shifts" report for the selected record. Only available for the "Job Current Activity", "Job Payroll Detail", "Job Payroll Shifts", and "Job Payroll Summary" report types.
New	Opens the Payroll Timesheet form, which is used to add hours to the current activity report for the current Worker. Only available for the "Job Current Activity", "Job Payroll Detail", "Job Payroll Shifts", "Job Payroll Summary", and "Workers by Job Category" report types.
Modify	On the the "Job Current Activity" and "Job Payroll Detail" reports, this button opens the Payroll Timesheet form, which is used to modify the hours, Operation, Job, and Work Center of the selected record. On the "Current Activity" report, this button opens the Edit Pay Time form, which is used to adjust a workers start date and time.
Preview Post	Opens a separate window indicating the posting that will occur once the hours have been posted to the general ledger. Only available for the "Job Payroll Shifts", "Job Payroll Summary", and "Workers by Job Category" report types. When calculating burden, the system will check the "Burden Posting Type" field in Accounting Options.
Export	Exports the currently displayed information to a text file. Only available for the "Job Current Activity", "Job Payroll Detail", "Job Payroll Shifts", and "Job Payroll Summary" report types.
Scrub Time	If clicked, the system will use the "Actual Start" and "Actual End" times on the Worker or Labor Group schedule and not the "Early Start", "Late Start", "Early End", and "Late End" times. Only available for the "Job Payroll Shifts" report.
Scrub Overtime	If checked, when the "Scrub Time" button is clicked, any overtime for the selected Worker will be removed from the payroll record. Only available for the "Job Payroll Shifts" report.

Payroll Timesheet form

Opened via the "New" and "Modify" buttons on a Payroll Reporting report, the Payroll Timesheet form is used to add and modify hours and Job details for a Worker.

Button/Field	Description
View Unscrubbed	Opens a list of entered time that has not been scrubbed for the Worker.
Worker	Displays the Worker for whom time is being entered or modified.
Date In	Displays the Job log in date for the selected Worker or defaults to the current date if adding new time.
Date Out	Displays the Job log out date for the selected Worker or defaults to the current date if adding new time.
Time In	Displays the log in time for the selected Worker.
Time Out	Displays the log out time for the selected Worker.
Hours	Displays the total work time, in hours, for the selected Job, Work Center, and Operation. Users with the "Production -- allow negative time sheet hours" security set to yes can enter negative times sheet hours to offset mistakes.
Overtime	Displays the total overtime, in hours, for the selected Job, Work Center, and Operation. Used in conjunction with the "OT Factor" field to calculate the Worker's overtime pay.
Rate Factor	Used in conjunction with the "Rate" field to indicate the factor with which the Worker's pay will be calculated. Example: If "Rate Factor" is set to 1.00 and "Rate" is set to 10.00, the Worker is paid 10.00 per hour.
OT Factor	Displays the overtime factor as defined by the "OT Factor" field on the Worker's General tab. Used in conjunction with the "Overtime" field to calculate the Worker's overtime pay.
Facility	Displays the Facility associated with the payroll entry. The system uses the following logic to determine the default Facility that is entered in this field. First, check the current user's Facility user restriction and use that if set. Next, check the selected worker's default Facility (wo_waid) from the Worker's record via Production > Maintenance > Workers. Then, check the system default Facility If none of the above are found, leave this blank and available for selection by the user.
Job Number	Displays the job number associated with the payroll entry. The job numbers available for selection are filtered to only jobs in the selected Facility above.
Work Center	Displays the Work Center associated with the payroll entry. The Work Centers available for selection are filtered to only Work Centers in Shop Areas associated with the selected Facility.
Operation	Displays the Operation associated with the payroll entry. If the "Restrict Operations to Routings in Log On/Off Jobs" flag is set on the Facility record, the Routings available for selection are filtered to only Operations for the selected job's Routings.
Work Crew	Displays the Crew to which the Worker belongs that is associated with the payroll entry.
Quantity	Indicates the quantity or number of pieces produced by the Worker or Crew for the selected Job. Used for reporting purposes only and does not represent quantity finished on the Job. Information entered in this field will not impact the Job quantity.
Rate	Displays the pay rate as defined by the "Hourly Rate" field on the Worker's General tab. Used in conjunction with the "Rate Factor" field to calculate the Worker's pay. If the security setting "Payroll Management -- View Rates" is set to no, this field will not be displayed on the form.
Operation Complete	Used for reporting purposes to indicate that this operation, for the selected job, is complete. Once checked, can only be unchecked by navigating directly to the specific routing sequence on the job and un checking it. In order for this flag to activate for selection, the user will need to select a Work Center and Operation that match those on the job's routing. The j2_done field may be added to the Job Payroll Detail report to verify if the operation is complete or not complete.

Edit Pay Time form

Opened via the "Modify" button on the Current Activity and Sign On/Off reports. The form is used to adjust the start and end time for workers and can be used to log out a worker for the day by populating the End Date and End Time fields. This logs the worker out for the day and logs them off any jobs they are logged into.

Button/Field	Description
Start Date	The worker's start date
Start Time	The worker's start time
End Date	The worker's end date
End Time	The worker's end time